#!/usr/bin/env python
# -*- coding:utf-8 -*-

import xlwt
import xlrd

def read_excel(filename,sheetname):
    rbook = xlrd.open_workbook(filename)#打开excel文件
    print(rbook.sheet_names())  # 获取所有表格名字
    sheet = rbook.sheet_by_name(sheetname) #通过sheet name获取sheet页内容
    # sheet = rbook.sheets()[0]  # 通过索引顺序获取
    # sheet = rbook.sheet_by_index(0)  # 通过索引顺序获取

    rows = sheet.nrows
    cellname = sheet.cell_value()


